package bom.example.common.sql;

/**
 * @author X.I.O
 * @title: SelectTable
 * @projectName spring-boot-luncene
 * @description: TODO
 * @date 2021/11/16 14:54
 */
public class SelectTable {

    /**
     * mysql 查询一张表的详细信息
     * @param table
     * @return
     */
    public static String selectTableInfo(String table){
        String s="select column_name as field, column_comment as note from INFORMATION_SCHEMA.Columns where table_name='%s'";
        return String.format(s,table);
    }


}
